/*
 * Copyright 2023-2085 xujin <ceo@itgrail.com>
 *
 * Licensed under the Grail License, Version 1.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 * https://itgrail.com/docs?id=3&catalogId=87
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
package com.itgrail.pilot.infrastructure.tunnel.db.dao;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.google.common.collect.Lists;
import com.itgrail.pilot.infrastructure.tunnel.db.dataobject.RoleDO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.util.CollectionUtils;

import java.util.List;
import java.util.Optional;


@Mapper
public interface RoleMapper extends BaseMapper<RoleDO> {

    /**
     * 查找有效的角色
     *
     * @param roles
     * @return
     */
    public default List<RoleDO> findValidRoles(List<String> roles) {
        if (CollectionUtils.isEmpty(roles)) {
            return Lists.newArrayList();
        }
        QueryWrapper<RoleDO> queryWrapper = new QueryWrapper<>();
        queryWrapper.in("`key`", roles);
        queryWrapper.eq("is_deleted", 0);
        return Optional.ofNullable(selectList(queryWrapper)).orElse(Lists.newArrayList());
    }

    /**
     * @return
     */
    public default List<RoleDO> getAllRoles() {
        QueryWrapper<RoleDO> queryWrapper = new QueryWrapper<>();
        queryWrapper.eq("is_deleted", 0);
        return Optional.ofNullable(selectList(queryWrapper)).orElse(Lists.newArrayList());
    }

    /**
     * 根据key查询角色
     *
     * @param key
     * @return
     */
    @Select("SELECT * FROM t_role where is_deleted=0 and `key`=#{key} ")
    RoleDO queryRoleByKey(String key);

}
